/**
 * 
 */
package org.gov.vis.util;

/**
 * @author Vishwanath
 *
 */
public class DBConstants {
	
	public static final String MYSQL_DATE_FORMAT = "yyyy-MM-dd";
	public static final String DISPLAY_DATE_FORMAT = "dd/MM/yyyy";

	//constants for the default values in the drop-down/combo boxes
	public static final long HEADER_DEFAULT_KEY = -1;
	public static final String HEADER_DEFAULT_VALUE = "-------Please Select-------";
	
	
	//constants for the Employment/Job Type
	public static final long JOB_TYPE_CONTRACT_KEY = 1L;
	public static final long JOB_TYPE_REGULAR_KEY = 2L;
	public static final long JOB_TYPE_OUTSOURCE_KEY = 3L;

	public static final String JOB_TYPE_CONTRACT_VALUE = "Contract";
	public static final String JOB_TYPE_REGULAR_VALUE = "Regular";
	public static final String JOB_TYPE_OUTSOURCE_VALUE = "Out Sourcing";
	
	public static final int PROGENCY_FOLLOWUP_DEWORMING = 1;
	public static final int PROGENCY_FOLLOWUP_VACCINATION = 2;
	public static final int PROGENCY_FOLLOWUP_DETICKING = 3;
	
	//constants for the Animal Type
	public static final long ANIMAL_TYPE_BUFFALOW_KEY = 1L;
	public static final long JOB_TYPE_COW_KEY = 2L;

	
	//constants for the sex Type
	public static final long PROGENCY_SEX_MALE_KEY = 0L;
	public static final long PROGENCY_SEX_FEMALE_KEY = 1L;

	
	public static final String PROGENCY_SEX_MALE_VALUE = "Male";
	public static final String PROGENCY_SEX_FEMALE_VALUE = "Female";
	
	//constants for the Animal Type
	public static final String AI_ANIMAL_TYPE_BUFFALOW = "Buffalow";
	public static final String AI_ANIMAL_TYPE_COW = "Cow";

	public static final String COL_DEPARTMENT_ID = "dpt_id";
	
	public static final String COL_DEPARTMENT_CODE = "dpt_code";
	
	public static final String COL_DEPARTMENT_INST = "dpt_inst";
	
	public static final String COL_DEPARTMENT_VLG = "dpt_vlg";
	
	public static final String COL_DEPARTMENT_MDL = "dpt_mdl";
	
	public static final String COL_DEPARTMENT_DIST = "dpt_dst";
	

    // Gopalamithra	
	public static final String COL_GOPALAMITHRA_ID = "gpm_id";
	
	public static final String COL_GOPALAMITHRA_CODE = "gpm_code";
	
	public static final String COL_GOPALAMITHRA_NAME = "gpm_name";
	
	public static final String COL_GOPALAMITHRA_FIRST_NAME = "gpm_first_name";
	
	public static final String COL_GOPALAMITHRA_DOB = "gpm_dob";
	
	public static final String COL_GOPALAMITHRA_NATIVE_VILLAGE = "gpm_ntv_vlg";
	
	public static final String COL_GOPALAMITHRA_MANDAL = "gpm_mdl";
	
	public static final String COL_GOPALAMITHRA_DISTRICT = "gpm_dst";
	
	public static final String COL_GOPALAMITHRA_JURIDICTION = "gpm_jrsdtn";
	
	public static final String COL_GOPALAMITHRA_HEADQUARTER = "gpm_hq";
	
	public static final String COL_GOPALAMITHRA_HEADQUARTER_MANDAL  = "gpm_hqmdl";
	
	public static final String COL_GOPALAMITHRA_HEADQUARTER_DISTRICT = "gpm_hqdst";
	
	//Other
	
	public static final String COL_OTHER_ID = "oth_id";
	
	public static final String COL_OTHER_CODE = "oth_code";
	
	public static final String COL_OTHER_ORGANIZATION = "oth_org";
	
	public static final String COL_OTHER_AI_WORKER = "oth_name_aiworker";
	
	public static final String COL_OTHER_HEADQUARTER = "oth_hq";
	
	public static final String COL_OTHER_JURIDICTION = "oth_jrsdtn";
	
	public static final String COL_OTHER_MANDAL = "oth_mdl";
	
	public static final String COL_OTHER_DISTRICT = "oth_dst";
	
	
	// Staff
	public static final String COL_STAFF_ID = "stf_id";
	
	public static final String COL_STAFF_CODE = "stf_code";
	
	public static final String COL_STAFF_NAME = "stf_name";
	
	public static final String COL_STAFF_FATHER_NAME = "stf_father_name";
	
	public static final String COL_STAFF_DOB = "stf_dob";
	
	public static final String COL_STAFF_QUALIFICATION = "stf_qualf";
	
	public static final String COL_STAFF_DESIGNATION = "stf_dsg";
	
	public static final String COL_STAFF_JOB_TYPE = "stf_job_type";
	
	public static final String COL_STAFF_DOJ = "stf_doj";
	
	public static final String COL_STAFF_VILLAGE = "stf_vlg";
	
	public static final String COL_STAFF_MANDAL = "stf_mdl";
	
	public static final String COL_STAFF_DISTRICT = "stf_dst";
	
	//AI
	
	public static final String COL_AI_ID = "ai_id";
	
	public static final String COL_AI_CODE = "ai_code";
	
	public static final String COL_AI_DOI = "ai_doi";
	
	public static final String COL_AI_TOI = "ai_toi";
	
	public static final String COL_AI_BREED = "ai_breed";
	
	public static final String COL_AI_BULLNO = "ai_bullno";
	
	public static final String COL_AI_NOAI = "ai_noai";
	
	public static final String COL_AI_FEE = "ai_fee";
	
	public static final String COL_AI_RECEIPT = "ai_receipt";
	
	public static final String COL_AI_CATTLE_OWNER = "ai_cattle_owner";
	
	public static final String COL_AI_VILLAGE = "ai_vlg";
	
	public static final String COL_AI_MANDAL = "ai_mdl";
	
	public static final String COL_AI_ANIMAL_TYPE = "ai_anm_typ";
	
	public static final String COL_AI_ANIMAL_KIND = "ai_anm_knd";
	
	public static final String COL_AI_BIRTHS_GIVEN = "ai_brth_gvn";
	
	//progency
	
	public static final String COL_PROGENCY_ID = "prgy_id";
	
	public static final String COL_PROGENCY_CODE = "prgy_code";
	
	public static final String COL_PROGENCY_FARMER_CODE = "prgy_frmr_code";
	
	public static final String COL_PROGENCY_FARMER_NAME = "prgy_frmr_name";
	
	public static final String COL_PROGENCY_RELATIONSHIP_NAME = "prgy_rltnshp_name";
	
	public static final String COL_PROGENCY_VILLAGE = "prgy_vlg";
	
	public static final String COL_PROGENCY_MANDAL = "prgy_mdl";
	
	public static final String COL_PROGENCY_DISTRICT = "prgy_dst";
	
	public static final String COL_PROGENCY_CALF_DOB = "prgy_calf_dob";
	
	public static final String COL_PROGENCY_BREED_TYPE = "prgy_breed_type";
	
	public static final String COL_PROGENCY_PERCENTAGE = "prgy_prcnt";
	
	public static final String COL_PROGENCY_SEX = "prgy_sex";
	
	public static final String COL_PROGENCY_COLOR = "prgy_color";
	
	public static final String COL_PROGENCY_TAGNO = "prgy_tagno";
	
	public static final String COL_PROGENCY_BREED = "prgy_breed";
	
	public static final String COL_PROGENCY_CALVING_NUM = "prgy_calving_num";
	
	public static final String COL_PROGENCY_AI_NUM = "prgy_ai_num";
	
	public static final String COL_PROGENCY_PREVIOUS_YIELD = "prgy_prv_yield";
	
	public static final String COL_PROGENCY_PRESENT_YIELD = "prgy_prst_yield";
	
	public static final String COL_PROGENCY_BULLNO = "prgy_bullno";
	
	//public static final String COL_PROGENCY_BIRTH_WEIGHT = "prgy_brth_wgt";
	
	//public static final String COL_PROGENCY_MONTHLY_WEIGHT = "prgy_mth_wgt";
	
	public static final String COL_PROGENCY_DM_MILK = "prgy_dm_milk";
	
	public static final String COL_PROGENCY_SIRE_BREED = "prgy_sire_breed";
	
	//public static final String COL_PROGENCY_NUTRITION = "prgy_nutrition";
	
//ProcurementSemen
	
	
	public static final String COL_PROCUREMENT_SEMEN_CODE = "ps_code";
	
	public static final String COL_PROCUREMENT_SEMEN_ID = "ps_id";
	
	public static final String COL_PROCUREMENT_SEMEN_DORCPT = "ps_rcpt";
	
	public static final String COL_PROCUREMENT_SEMEN_FRMSTATON = "ps_frmStat";
	
	public static final String COL_PROCUREMENT_SEMEN_BREED = "ps_breed";
	
	public static final String COL_PROCUREMENT_SEMEN_BULLNO = "ps_bullNo";
	
	public static final String COL_PROCUREMENT_SEMEN_NOSTRAWS = "ps_noStraws";
	
	public static final String COL_PROCUREMENT_SEMEN_DSCORD = "ps_dscrd";
	
	//procurementLN
	
	public static final String COL_PROCUREMENT_LN_ID = "pln_id";
	
	public static final String COL_PROCUREMENT_LN_CODE = "pln_code";
	
	public static final String COL_PROCUREMENT_LN_DORCPT = "pln_rcpt";
	
	public static final String COL_PROCUREMENT_LN_KGS = "pln_kgs";

	public static final String COL_PROCUREMENT_LN_CNVRTDLTRS = "pln_cnvrtLtrs";
	
	public static final String COL_PROCUREMENT_LN_FRMSTATION = "pln_frmStat";
	
	public static final String COL_PROCUREMENT_LN_VEHICLENO = "pln_vhclNo";
	
	public static final String COL_PROCUREMENT_LN_EVOPRLOSS = "pln_evopLoss";
	
	//DistributionSemen
	
	public static final String COL_DISTRIBUTON_SEMEN_ID = "ds_id";
	
	public static final String COL_DISTRIBUTON_SEMEN_CODE = "ds_code";
	
	public static final String COL_DISTRIBUTON_SEMEN_DODSTRB = "ds_dt_dstrbtn";
	
	public static final String COL_DISTRIBUTON_SEMEN_BREED = "ds_breed";
	
	public static final String COL_DISTRIBUTON_SEMEN_BULLNO = "ds_bulNo";
	
	public static final String COL_DISTRIBUTON_SEMEN_NoSTRAWS = "ds_no_straws";
	
	public static final String COL_DISTRIBUTON_SEMEN_VALUE = "ds_value";
	
	public static final String COL_DISTRIBUTON_SEMEN_DISCORD = "ds_dcrd";
	
	//DistributonLN
	
	public static final String COL_DISTRIBUTON_LN_ID = "dln_id";
	
	public static final String COL_DISTRIBUTION_LN_CODE = "dln_code";
	
	public static final String COL_DISTRIBUTON_LN_DODSTRB = "dln_dt_dstrbtn";
	
	public static final String COL_DISTRIBUTON_LN_KGS = "dln_kgs";
	
	public static final String COL_DISTRIBUTON_LN_CNVRTDLTRS = "dln_cnvtrdLtrs";
	
	public static final String COL_DISTRIBUTON_LN_FRMSTATON = "dln_frmstat";
	
	public static final String COL_DISTRIBUTON_LN_VEHICLENO = "dln_vehno";
	
	public static final String COL_DISTRIBUTON_LN_EVOPOSS = "dln_evoploss";
	
	//progencyFollowup
	public static final String COL_PROGENCY_FOLLOWUP_ID = "prgy_flw_id";
	
	//public static final String COL_PROGENCY_FOLLOWUP_TYPE = "prgy_flw_type";
	
	public static final String COL_PROGENCY_FOLLOWUP_DEWORMING_DATE = "prgy_flw_deworm_date";
	
	public static final String COL_PROGENCY_FOLLOWUP_VACCINATION_DATE = "prgy_flw_vacc_date";
	
	public static final String COL_PROGENCY_FOLLOWUP_DETICKING_DATE = "prgy_flw_detick_date";
	
	//public static final String COL_PROGENCY_FOLLOWUP_ACTION = "prgy_flw_action";
	
	public static final String COL_PROGENCY_FOLLOWUP_PROGENCYID = "prgy_flw_prgyid";
	
	public static final String COL_PROGENCY_FOLLOWUP_BIRTH_WEIGHT = "prgy_flw_brth_wgt";
	
	public static final String COL_PROGENCY_FOLLOWUP_MONTHLY_WEIGHT = "prgy_flw_mth_wgt";
	
	public static final String COL_PROGENCY_FOLLOWUP_OTHER = "prgy_flw_othr";
	
	public static final String COL_PROGENCY_FOLLOWUP_NUTRITION = "prgy_flw_nutrition";
	
}//end class
